home *** CD-ROM | disk | FTP | other *** search
/ New Perspectives on Computer Concepts / New Perspectives on Computer Concepts.iso / np2010c / page685.pag < prev    next >
Portable Network Graphic  |  2008-10-02  |  67KB  |  817x1045  |  8-bit (256 colors)
Labels: hakham | workwear
OCR: DATABASES 6 1 7 What kind of databases track relationships? Except for flat files, other database models allow you to track relationships. The way database models work with relationships is a key to their differences. hierarchical database allows one -to-one and one-to-many relationships, linked in a hierarchical structure. A network database uses mesh-like structure offer the additional capacity to define many -to-many relationships. Compare the structures of these two database models in Figure 11-10 and Figure 11-11 FIGURE 11-10 Customer In this hierarchical database Customers Albums Tracks, and Orders are record types. All of the relationships are one-to- Order Order Order many Album Albun Album Album Album Album Album Track Track Track FIGURE 11-11 Customer A network database allows ma ...